As water crisis lingers, some remain optimistic that buyers and renters haven’t given up on living in the city